Table

A table can be a source, target, or both in a mapping specification. It can also be used for transformations, such as business rules and lookups in a mapping project. The impact analysis on a table helps you identify these impacts of the table on mapping projects.

To run impact analysis at table level, follow these steps:

  1. Go to Application Menu > Data Catalog > Metadata Manager > Explore.
  2. In the System Catalogue pane, click a table.
  3. Click the Impact Analysis tab.

    4. By default, the Direct Impact tab opens. It displays the impact of the table as source and target.

    To view the indirect impact, click the Indirect Impact tab.

    It displays the upstream and downstream impact of the table.


    To view other impacts, click the Other Impacts tab.

    It displays the impact of the table on:

    • Business rules
    • Source Extract SQL
    • Lookups

You can also perform impact analysis at the following levels: